Long[].FindSorted (gb)
Function FindSorted ( Value As Long [ , Start As Integer ] ) As Integer
Since 3.16
Returns the position of
Value in the array.
If
Start is specified, then the search begins at the
Start position. By default the entire array is searched.
If
Value cannot be found, a negative value is returned. It equals
-1 - pos, where
pos is the position
Value should be inserted at to keep the array sorted.
This method only works if the array is sorted.
Moreover, if
Value is not unique, the returned position is not necessarily the first one.
But it is faster than the
Find method as it uses a binary search algorithm.